﻿CREATE TABLE [dbo].[ASMS_StockChangedRecord]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
    [StockId] uniqueidentifier NOT NULL,
	[WarehouseId] uniqueidentifier NOT NULL,
	[MaterialId] uniqueidentifier NOT NULL,
	[Type] int NOT NULL,
	[SalesMode] int,
	[BillId] uniqueidentifier NOT NULL,
	[BillNumber] nvarchar(64) NOT NULl,
	[BillType] int NOT NULL,
	[Cost] money,
	[Count] money,
	[RemainingCount] money,
	[RemainingCost] money,
	[CreatedTime] datetime NOT NULL,
	[Creator] nvarchar(64) NOT NULL
)
